<?php
	include("class/conmssql.php");
	include("class/function.php");

	$sqlquery = msssqlselectdata("*","Usernames INNER JOIN UserDetail ON Usernames.pkUser = UserDetail.pkUser","");
	$sqlqueryproject = msssqlselectdata("*","[dbo].[Project]","pkProject <> 1");
	$sqlquryrole = msssqlselectdata("*","[dbo].[Roles]","");
	
if($_REQUEST['idproject'] != '')
{
	$queryeditproject = msssqlselectdata("","","");
}	

if($_REQUEST['page'] == 'piezometer/view_allpiezometer')
{
	$alltools = msssqlselectdata("*","
	[dbo].[ProjectTools] 
						 INNER JOIN [dbo].[ToolType] ON [dbo].[ProjectTools].fkToolType = [dbo].[ToolType].pkToolType
						 INNER JOIN [dbo].[Project] ON [dbo].[ProjectTools].fkProject = [dbo].[Project].pkProject
						 INNER JOIN [dbo].[Piezometer] ON [dbo].[ProjectTools].fkTool = [dbo].[Piezometer].pkTool
	","[dbo].[ProjectTools].fkToolType = '1'");
}
	
?>

	<div><?php include 'header.php' ?></div>

	<div class="container content blog">
		<hr />
		<div class="row">
			<div class="col-sm-3">
            
				<div class="well sidebar-nav">
					<ul class="nav nav-list">
						<li class="nav-header">Menu</li>
						<li class="active"><a href="admin.php?page=">ดูแผนที่เขื่อน</a></li>
						<li><a href="admin.php?page=project/viewallproject">โครงการ</a></li>
						<li><a href="admin.php?page=piezometer/view_allpiezometer">View/Edit all instruments</a></li>
                        
					</ul>
				</div>    
			
				   	
			</div> <!-- //end span3 -->

			
				
				<?php
				if($_REQUEST['page'] == ""){
				include("map/maps.php");
				}else{
				include($_REQUEST['page'].".php");
				}
				?>
						
				
		</div> <!-- //end row -->	
		
		<hr>	
	</div> <!-- //end container -->		
	
		
	
					
	<footer>
		<div class="container">
			<div class="row">				
					<p>Copyright &copy; 2013 Infratech ASTM CO.,LTD. All rights reserved.</p>		
			</div>
		</div>   <!--//end container -->   
	</footer>


</body>
</html>